/*
 Navicat MySQL Data Transfer

 Source Server         : MAMP
 Source Server Type    : MySQL
 Source Server Version : 50721
 Source Host           : localhost:3306
 Source Schema         : wx_code

 Target Server Type    : MySQL
 Target Server Version : 50721
 File Encoding         : 65001

 Date: 23/05/2019 19:10:32
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for l_config
-- ----------------------------
DROP TABLE IF EXISTS `l_config`;
CREATE TABLE `l_config` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `nickname` varchar(100) DEFAULT NULL,
  `name` varchar(255) DEFAULT NULL,
  `value` varchar(255) DEFAULT NULL,
  `status` int(11) DEFAULT '1',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of l_config
-- ----------------------------
BEGIN;
INSERT INTO `l_config` VALUES (1, '授权地址', 'go_url', 'http://wxcode.com?login_id=', 1);
COMMIT;

-- ----------------------------
-- Table structure for l_login_info
-- ----------------------------
DROP TABLE IF EXISTS `l_login_info`;
CREATE TABLE `l_login_info` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(100) DEFAULT NULL,
  `tourl` varchar(255) DEFAULT NULL,
  `goid` varchar(100) DEFAULT NULL,
  `create_time` varchar(100) DEFAULT NULL,
  `url` varchar(255) DEFAULT NULL,
  `status` int(11) DEFAULT '1',
  `is_delete` int(11) DEFAULT '0',
  `ip` varchar(100) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of l_login_info
-- ----------------------------
BEGIN;
INSERT INTO `l_login_info` VALUES (2, 'asd', 'http://baidu.com', 'weixinpGHCAGNirk', '1558603835', 'http://baidu.com', 1, 1, '127.0.0.1');
INSERT INTO `l_login_info` VALUES (3, 'test', 'http://test.95ym.cn', 'weixinFibMlIPXJY', '1558603876', 'http://test.95ym.cn', 1, 0, '127.0.0.1');
COMMIT;

-- ----------------------------
-- Table structure for l_login_log
-- ----------------------------
DROP TABLE IF EXISTS `l_login_log`;
CREATE TABLE `l_login_log` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `i_id` int(11) DEFAULT NULL,
  `time` varchar(30) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Table structure for l_user
-- ----------------------------
DROP TABLE IF EXISTS `l_user`;
CREATE TABLE `l_user` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) DEFAULT NULL,
  `passwd` varchar(255) DEFAULT NULL,
  `status` int(11) DEFAULT '1',
  `last_time` varchar(100) DEFAULT NULL,
  `is_delete` int(11) NOT NULL DEFAULT '0' COMMENT '0未删除1已删除',
  `create_time` varchar(100) DEFAULT NULL,
  `header_img` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of l_user
-- ----------------------------
BEGIN;
INSERT INTO `l_user` VALUES (1, 'admin', '0c80748069196ba5f5da26f1102ea0b7', 1, '1558603441', 0, '1558602242', 'http://csstools.chinaz.com/tools/images/public/logos/logo-index.png');
COMMIT;

SET FOREIGN_KEY_CHECKS = 1;
